SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
CREATE PROCEDURE [dbo].[paEliminarColaDeMovimientos]

@IdCola INT

AS
SET NOCOUNT ON
SET DATEFORMAT dmy

-- Instruccion renombrada porque le agregamos un trigger a la tabla Tb_ColaDeMovimientos y este Delete lo hacemos ahi -- 15-06-2010
--DELETE FROM tb_PlazasDeMovimiento WHERE IdCola = @IdCola

DELETE FROM tb_ColaDeMovimientos WHERE IdCola = @IdCola
GO
GRANT EXECUTE ON  [dbo].[paEliminarColaDeMovimientos] TO [GestionInstitucional]
GRANT EXECUTE ON  [dbo].[paEliminarColaDeMovimientos] TO [PersonalDocente]
GO
